Overview
Brought to you by YData
Dataset statistics
| Number of variables | 34 |
|---|---|
| Number of observations | 3313522 |
| Missing cells | 16496269 |
| Missing cells (%) | 14.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 859.5 MiB |
| Average record size in memory | 272.0 B |
Variable types
| DateTime | 3 |
|---|---|
| Categorical | 8 |
| Numeric | 15 |
| Text | 8 |
AIRLINE has constant value "Southwest Airlines Co." | Constant |
AIRLINE_DOT has constant value "Southwest Airlines Co.: WN" | Constant |
AIRLINE_CODE has constant value "WN" | Constant |
DOT_CODE has constant value "19393" | Constant |
CANCELLED is highly imbalanced (83.8%) | Imbalance |
DIVERTED is highly imbalanced (97.7%) | Imbalance |
DEP_DELAY has 77821 (2.3%) missing values | Missing |
TAXI_OUT has 78301 (2.4%) missing values | Missing |
TAXI_IN has 79338 (2.4%) missing values | Missing |
ARR_DELAY has 85785 (2.6%) missing values | Missing |
CANCELLATION_CODE has 3235034 (97.6%) missing values | Missing |
ELAPSED_TIME has 85785 (2.6%) missing values | Missing |
AIR_TIME has 85785 (2.6%) missing values | Missing |
DELAY_DUE_CARRIER has 2553684 (77.1%) missing values | Missing |
DELAY_DUE_WEATHER has 2553684 (77.1%) missing values | Missing |
DELAY_DUE_NAS has 2553684 (77.1%) missing values | Missing |
DELAY_DUE_SECURITY has 2553684 (77.1%) missing values | Missing |
DELAY_DUE_LATE_AIRCRAFT has 2553684 (77.1%) missing values | Missing |
DELAY_DUE_SECURITY is highly skewed (γ1 = 49.64198616) | Skewed |
DEP_DELAY has 215759 (6.5%) zeros | Zeros |
ARR_DELAY has 66616 (2.0%) zeros | Zeros |
DELAY_DUE_CARRIER has 243307 (7.3%) zeros | Zeros |
DELAY_DUE_WEATHER has 744337 (22.5%) zeros | Zeros |
DELAY_DUE_NAS has 470725 (14.2%) zeros | Zeros |
DELAY_DUE_SECURITY has 756232 (22.8%) zeros | Zeros |
DELAY_DUE_LATE_AIRCRAFT has 232743 (7.0%) zeros | Zeros |
Reproduction
| Analysis started | 2024-10-18 17:44:06.424090 |
|---|---|
| Analysis finished | 2024-10-18 17:46:38.645476 |
| Duration | 2 minutes and 32.22 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
Variables
FL_DATE
Date
| Distinct | 973 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 MiB |
| Minimum | 2021-01-01 00:00:00 |
|---|---|
| Maximum | 2023-08-31 00:00:00 |
AIRLINE
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 MiB |
| Southwest Airlines Co. |
|---|
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Southwest Airlines Co. |
|---|---|
| 2nd row | Southwest Airlines Co. |
| 3rd row | Southwest Airlines Co. |
| 4th row | Southwest Airlines Co. |
| 5th row | Southwest Airlines Co. |
Common Values
| Value | Count | Frequency (%) |
| Southwest Airlines Co. | 3313522 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| southwest | 3313522 | |
| airlines | 3313522 | |
| co | 3313522 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 6627044 | 9.1% |
| t | 6627044 | 9.1% |
| e | 6627044 | 9.1% |
| s | 6627044 | 9.1% |
| 6627044 | 9.1% | |
| i | 6627044 | 9.1% |
| S | 3313522 | 4.5% |
| u | 3313522 | 4.5% |
| h | 3313522 | 4.5% |
| w | 3313522 | 4.5% |
| Other values (6) | 19881132 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 72897484 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 6627044 | 9.1% |
| t | 6627044 | 9.1% |
| e | 6627044 | 9.1% |
| s | 6627044 | 9.1% |
| 6627044 | 9.1% | |
| i | 6627044 | 9.1% |
| S | 3313522 | 4.5% |
| u | 3313522 | 4.5% |
| h | 3313522 | 4.5% |
| w | 3313522 | 4.5% |
| Other values (6) | 19881132 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 72897484 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 6627044 | 9.1% |
| t | 6627044 | 9.1% |
| e | 6627044 | 9.1% |
| s | 6627044 | 9.1% |
| 6627044 | 9.1% | |
| i | 6627044 | 9.1% |
| S | 3313522 | 4.5% |
| u | 3313522 | 4.5% |
| h | 3313522 | 4.5% |
| w | 3313522 | 4.5% |
| Other values (6) | 19881132 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 72897484 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 6627044 | 9.1% |
| t | 6627044 | 9.1% |
| e | 6627044 | 9.1% |
| s | 6627044 | 9.1% |
| 6627044 | 9.1% | |
| i | 6627044 | 9.1% |
| S | 3313522 | 4.5% |
| u | 3313522 | 4.5% |
| h | 3313522 | 4.5% |
| w | 3313522 | 4.5% |
| Other values (6) | 19881132 |
AIRLINE_DOT
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 MiB |
| Southwest Airlines Co.: WN |
|---|
Length
| Max length | 26 |
|---|---|
| Median length | 26 |
| Mean length | 26 |
| Min length | 26 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Southwest Airlines Co.: WN |
|---|---|
| 2nd row | Southwest Airlines Co.: WN |
| 3rd row | Southwest Airlines Co.: WN |
| 4th row | Southwest Airlines Co.: WN |
| 5th row | Southwest Airlines Co.: WN |
Common Values
| Value | Count | Frequency (%) |
| Southwest Airlines Co.: WN | 3313522 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| southwest | 3313522 | |
| airlines | 3313522 | |
| co | 3313522 | |
| wn | 3313522 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9940566 | 11.5% | |
| t | 6627044 | 7.7% |
| e | 6627044 | 7.7% |
| s | 6627044 | 7.7% |
| o | 6627044 | 7.7% |
| i | 6627044 | 7.7% |
| S | 3313522 | 3.8% |
| n | 3313522 | 3.8% |
| W | 3313522 | 3.8% |
| : | 3313522 | 3.8% |
| Other values (9) | 29821698 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 86151572 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 9940566 | 11.5% | |
| t | 6627044 | 7.7% |
| e | 6627044 | 7.7% |
| s | 6627044 | 7.7% |
| o | 6627044 | 7.7% |
| i | 6627044 | 7.7% |
| S | 3313522 | 3.8% |
| n | 3313522 | 3.8% |
| W | 3313522 | 3.8% |
| : | 3313522 | 3.8% |
| Other values (9) | 29821698 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 86151572 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 9940566 | 11.5% | |
| t | 6627044 | 7.7% |
| e | 6627044 | 7.7% |
| s | 6627044 | 7.7% |
| o | 6627044 | 7.7% |
| i | 6627044 | 7.7% |
| S | 3313522 | 3.8% |
| n | 3313522 | 3.8% |
| W | 3313522 | 3.8% |
| : | 3313522 | 3.8% |
| Other values (9) | 29821698 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 86151572 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 9940566 | 11.5% | |
| t | 6627044 | 7.7% |
| e | 6627044 | 7.7% |
| s | 6627044 | 7.7% |
| o | 6627044 | 7.7% |
| i | 6627044 | 7.7% |
| S | 3313522 | 3.8% |
| n | 3313522 | 3.8% |
| W | 3313522 | 3.8% |
| : | 3313522 | 3.8% |
| Other values (9) | 29821698 |
AIRLINE_CODE
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 MiB |
| WN |
|---|
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | WN |
|---|---|
| 2nd row | WN |
| 3rd row | WN |
| 4th row | WN |
| 5th row | WN |
Common Values
| Value | Count | Frequency (%) |
| WN | 3313522 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| wn | 3313522 |
Most occurring characters
| Value | Count | Frequency (%) |
| W | 3313522 | |
| N | 3313522 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6627044 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| W | 3313522 | |
| N | 3313522 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6627044 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| W | 3313522 | |
| N | 3313522 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6627044 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| W | 3313522 | |
| N | 3313522 |
DOT_CODE
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 MiB |
| 19393 |
|---|
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 19393 |
|---|---|
| 2nd row | 19393 |
| 3rd row | 19393 |
| 4th row | 19393 |
| 5th row | 19393 |
Common Values
| Value | Count | Frequency (%) |
| 19393 | 3313522 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 19393 | 3313522 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 6627044 | |
| 3 | 6627044 | |
| 1 | 3313522 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 16567610 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 9 | 6627044 | |
| 3 | 6627044 | |
| 1 | 3313522 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 16567610 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 9 | 6627044 | |
| 3 | 6627044 | |
| 1 | 3313522 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 16567610 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 9 | 6627044 | |
| 3 | 6627044 | |
| 1 | 3313522 |
FL_NUMBER
Real number (ℝ)
| Distinct | 6812 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2060.522 |
| Minimum | 1 |
|---|---|
| Maximum | 6999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 50.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 215 |
| Q1 | 945 |
| median | 1869 |
| Q3 | 2879 |
| 95-th percentile | 4884 |
| Maximum | 6999 |
| Range | 6998 |
| Interquartile range (IQR) | 1934 |
Descriptive statistics
| Standard deviation | 1409.6242 |
|---|---|
| Coefficient of variation (CV) | 0.68411022 |
| Kurtosis | 0.25919642 |
| Mean | 2060.522 |
| Median Absolute Deviation (MAD) | 962 |
| Skewness | 0.79923221 |
| Sum | 6.827585 × 109 |
| Variance | 1987040.3 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 55 | 2131 | 0.1% |
| 311 | 1973 | 0.1% |
| 694 | 1858 | 0.1% |
| 1640 | 1768 | 0.1% |
| 110 | 1701 | 0.1% |
| 351 | 1681 | 0.1% |
| 953 | 1677 | 0.1% |
| 312 | 1646 | < 0.1% |
| 44 | 1642 | < 0.1% |
| 255 | 1639 | < 0.1% |
| Other values (6802) | 3295806 |
| Value | Count | Frequency (%) |
| 1 | 882 | |
| 2 | 743 | |
| 3 | 780 | |
| 4 | 1252 | |
| 5 | 835 | |
| 6 | 1038 | |
| 7 | 909 | |
| 8 | 440 | < 0.1% |
| 9 | 536 | < 0.1% |
| 10 | 1362 |
| Value | Count | Frequency (%) |
| 6999 | 9 | |
| 6998 | 1 | < 0.1% |
| 6997 | 2 | < 0.1% |
| 6996 | 1 | < 0.1% |
| 6995 | 3 | < 0.1% |
| 6994 | 1 | < 0.1% |
| 6993 | 2 | < 0.1% |
| 6992 | 9 | |
| 6991 | 2 | < 0.1% |
| 6990 | 1 | < 0.1% |
ORIGIN
Text
| Distinct | 107 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BWI |
|---|---|
| 2nd row | ATL |
| 3rd row | ATL |
| 4th row | ATL |
| 5th row | ATL |
| Value | Count | Frequency (%) |
| den | 220838 | 6.7% |
| las | 185768 | 5.6% |
| mdw | 183490 | 5.5% |
| dal | 166208 | 5.0% |
| bwi | 164385 | 5.0% |
| phx | 153079 | 4.6% |
| hou | 122857 | 3.7% |
| bna | 113040 | 3.4% |
| mco | 100394 | 3.0% |
| oak | 90811 | 2.7% |
| Other values (97) | 1812652 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 1229398 | 12.4% |
| S | 922880 | 9.3% |
| L | 894710 | 9.0% |
| D | 740601 | 7.5% |
| M | 603965 | 6.1% |
| N | 575518 | 5.8% |
| O | 513100 | 5.2% |
| B | 468334 | 4.7% |
| H | 400059 | 4.0% |
| C | 395880 | 4.0% |
| Other values (16) | 3196121 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9940566 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 1229398 | 12.4% |
| S | 922880 | 9.3% |
| L | 894710 | 9.0% |
| D | 740601 | 7.5% |
| M | 603965 | 6.1% |
| N | 575518 | 5.8% |
| O | 513100 | 5.2% |
| B | 468334 | 4.7% |
| H | 400059 | 4.0% |
| C | 395880 | 4.0% |
| Other values (16) | 3196121 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9940566 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 1229398 | 12.4% |
| S | 922880 | 9.3% |
| L | 894710 | 9.0% |
| D | 740601 | 7.5% |
| M | 603965 | 6.1% |
| N | 575518 | 5.8% |
| O | 513100 | 5.2% |
| B | 468334 | 4.7% |
| H | 400059 | 4.0% |
| C | 395880 | 4.0% |
| Other values (16) | 3196121 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9940566 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 1229398 | 12.4% |
| S | 922880 | 9.3% |
| L | 894710 | 9.0% |
| D | 740601 | 7.5% |
| M | 603965 | 6.1% |
| N | 575518 | 5.8% |
| O | 513100 | 5.2% |
| B | 468334 | 4.7% |
| H | 400059 | 4.0% |
| C | 395880 | 4.0% |
| Other values (16) | 3196121 |
ORIGIN_CITY
Text
| Distinct | 104 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 MiB |
Length
| Max length | 30 |
|---|---|
| Median length | 24 |
| Mean length | 12.28284 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Baltimore, MD |
|---|---|
| 2nd row | Atlanta, GA |
| 3rd row | Atlanta, GA |
| 4th row | Atlanta, GA |
| 5th row | Atlanta, GA |
| Value | Count | Frequency (%) |
| ca | 568536 | 7.5% |
| tx | 462803 | 6.1% |
| fl | 289117 | 3.8% |
| co | 235790 | 3.1% |
| denver | 220838 | 2.9% |
| san | 218145 | 2.9% |
| il | 206222 | 2.7% |
| chicago | 206222 | 2.7% |
| nv | 205176 | 2.7% |
| vegas | 185768 | 2.4% |
| Other values (155) | 4805114 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4290209 | 10.5% | |
| a | 3377275 | 8.3% |
| , | 3313522 | 8.1% |
| e | 2143215 | 5.3% |
| n | 2099277 | 5.2% |
| o | 2043071 | 5.0% |
| l | 1696941 | 4.2% |
| s | 1682316 | 4.1% |
| i | 1522934 | 3.7% |
| A | 1311883 | 3.2% |
| Other values (44) | 17218818 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 40699461 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4290209 | 10.5% | |
| a | 3377275 | 8.3% |
| , | 3313522 | 8.1% |
| e | 2143215 | 5.3% |
| n | 2099277 | 5.2% |
| o | 2043071 | 5.0% |
| l | 1696941 | 4.2% |
| s | 1682316 | 4.1% |
| i | 1522934 | 3.7% |
| A | 1311883 | 3.2% |
| Other values (44) | 17218818 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 40699461 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4290209 | 10.5% | |
| a | 3377275 | 8.3% |
| , | 3313522 | 8.1% |
| e | 2143215 | 5.3% |
| n | 2099277 | 5.2% |
| o | 2043071 | 5.0% |
| l | 1696941 | 4.2% |
| s | 1682316 | 4.1% |
| i | 1522934 | 3.7% |
| A | 1311883 | 3.2% |
| Other values (44) | 17218818 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 40699461 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4290209 | 10.5% | |
| a | 3377275 | 8.3% |
| , | 3313522 | 8.1% |
| e | 2143215 | 5.3% |
| n | 2099277 | 5.2% |
| o | 2043071 | 5.0% |
| l | 1696941 | 4.2% |
| s | 1682316 | 4.1% |
| i | 1522934 | 3.7% |
| A | 1311883 | 3.2% |
| Other values (44) | 17218818 |
DEST
Text
| Distinct | 107 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BNA |
|---|---|
| 2nd row | MCI |
| 3rd row | BWI |
| 4th row | BWI |
| 5th row | LGA |
| Value | Count | Frequency (%) |
| den | 220827 | 6.7% |
| las | 185755 | 5.6% |
| mdw | 183492 | 5.5% |
| dal | 166207 | 5.0% |
| bwi | 164382 | 5.0% |
| phx | 153072 | 4.6% |
| hou | 122851 | 3.7% |
| bna | 113036 | 3.4% |
| mco | 100367 | 3.0% |
| oak | 90808 | 2.7% |
| Other values (97) | 1812725 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 1229390 | 12.4% |
| S | 922900 | 9.3% |
| L | 894686 | 9.0% |
| D | 740614 | 7.5% |
| M | 603965 | 6.1% |
| N | 575521 | 5.8% |
| O | 513083 | 5.2% |
| B | 468338 | 4.7% |
| H | 400056 | 4.0% |
| C | 395871 | 4.0% |
| Other values (16) | 3196142 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9940566 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 1229390 | 12.4% |
| S | 922900 | 9.3% |
| L | 894686 | 9.0% |
| D | 740614 | 7.5% |
| M | 603965 | 6.1% |
| N | 575521 | 5.8% |
| O | 513083 | 5.2% |
| B | 468338 | 4.7% |
| H | 400056 | 4.0% |
| C | 395871 | 4.0% |
| Other values (16) | 3196142 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9940566 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 1229390 | 12.4% |
| S | 922900 | 9.3% |
| L | 894686 | 9.0% |
| D | 740614 | 7.5% |
| M | 603965 | 6.1% |
| N | 575521 | 5.8% |
| O | 513083 | 5.2% |
| B | 468338 | 4.7% |
| H | 400056 | 4.0% |
| C | 395871 | 4.0% |
| Other values (16) | 3196142 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9940566 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 1229390 | 12.4% |
| S | 922900 | 9.3% |
| L | 894686 | 9.0% |
| D | 740614 | 7.5% |
| M | 603965 | 6.1% |
| N | 575521 | 5.8% |
| O | 513083 | 5.2% |
| B | 468338 | 4.7% |
| H | 400056 | 4.0% |
| C | 395871 | 4.0% |
| Other values (16) | 3196142 |
DEST_CITY
Text
| Distinct | 104 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 MiB |
Length
| Max length | 30 |
|---|---|
| Median length | 24 |
| Mean length | 12.282894 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Nashville, TN |
|---|---|
| 2nd row | Kansas City, MO |
| 3rd row | Baltimore, MD |
| 4th row | Baltimore, MD |
| 5th row | New York, NY |
| Value | Count | Frequency (%) |
| ca | 568554 | 7.5% |
| tx | 462808 | 6.1% |
| fl | 289081 | 3.8% |
| co | 235783 | 3.1% |
| denver | 220827 | 2.9% |
| san | 218157 | 2.9% |
| il | 206229 | 2.7% |
| chicago | 206229 | 2.7% |
| nv | 205165 | 2.7% |
| vegas | 185755 | 2.4% |
| Other values (155) | 4805156 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4290222 | 10.5% | |
| a | 3377263 | 8.3% |
| , | 3313522 | 8.1% |
| e | 2143224 | 5.3% |
| n | 2099314 | 5.2% |
| o | 2043103 | 5.0% |
| l | 1696931 | 4.2% |
| s | 1682332 | 4.1% |
| i | 1522972 | 3.7% |
| A | 1311900 | 3.2% |
| Other values (44) | 17218857 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 40699640 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4290222 | 10.5% | |
| a | 3377263 | 8.3% |
| , | 3313522 | 8.1% |
| e | 2143224 | 5.3% |
| n | 2099314 | 5.2% |
| o | 2043103 | 5.0% |
| l | 1696931 | 4.2% |
| s | 1682332 | 4.1% |
| i | 1522972 | 3.7% |
| A | 1311900 | 3.2% |
| Other values (44) | 17218857 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 40699640 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4290222 | 10.5% | |
| a | 3377263 | 8.3% |
| , | 3313522 | 8.1% |
| e | 2143224 | 5.3% |
| n | 2099314 | 5.2% |
| o | 2043103 | 5.0% |
| l | 1696931 | 4.2% |
| s | 1682332 | 4.1% |
| i | 1522972 | 3.7% |
| A | 1311900 | 3.2% |
| Other values (44) | 17218857 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 40699640 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4290222 | 10.5% | |
| a | 3377263 | 8.3% |
| , | 3313522 | 8.1% |
| e | 2143224 | 5.3% |
| n | 2099314 | 5.2% |
| o | 2043103 | 5.0% |
| l | 1696931 | 4.2% |
| s | 1682332 | 4.1% |
| i | 1522972 | 3.7% |
| A | 1311900 | 3.2% |
| Other values (44) | 17218857 |
CRS_DEP_TIME
Date
| Distinct | 226 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 MiB |
| Minimum | 2024-10-18 05:00:00 |
|---|---|
| Maximum | 2024-10-18 23:55:00 |
DEP_TIME
Text
| Distinct | 1367 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 MiB |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 26 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 12:53 |
|---|---|
| 2nd row | 16:41 |
| 3rd row | 11:58 |
| 4th row | 17:29 |
| 5th row | 20:22 |
| Value | Count | Frequency (%) |
| 0:01 | 77821 | 2.3% |
| 06:00 | 7753 | 0.2% |
| 05:59 | 7361 | 0.2% |
| 05:58 | 6568 | 0.2% |
| 05:57 | 6311 | 0.2% |
| 05:56 | 5523 | 0.2% |
| 07:00 | 5486 | 0.2% |
| 05:55 | 5324 | 0.2% |
| 06:10 | 5279 | 0.2% |
| 06:55 | 5271 | 0.2% |
| Other values (1357) | 3180825 |
Most occurring characters
| Value | Count | Frequency (%) |
| : | 3313522 | |
| 1 | 3098589 | |
| 0 | 2406481 | |
| 2 | 1531188 | |
| 5 | 1257575 | 7.6% |
| 3 | 1042379 | 6.3% |
| 4 | 1018773 | 6.1% |
| 6 | 732757 | 4.4% |
| 8 | 713664 | 4.3% |
| 9 | 705946 | 4.3% |
| Other values (2) | 746736 | 4.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 16567610 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| : | 3313522 | |
| 1 | 3098589 | |
| 0 | 2406481 | |
| 2 | 1531188 | |
| 5 | 1257575 | 7.6% |
| 3 | 1042379 | 6.3% |
| 4 | 1018773 | 6.1% |
| 6 | 732757 | 4.4% |
| 8 | 713664 | 4.3% |
| 9 | 705946 | 4.3% |
| Other values (2) | 746736 | 4.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 16567610 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| : | 3313522 | |
| 1 | 3098589 | |
| 0 | 2406481 | |
| 2 | 1531188 | |
| 5 | 1257575 | 7.6% |
| 3 | 1042379 | 6.3% |
| 4 | 1018773 | 6.1% |
| 6 | 732757 | 4.4% |
| 8 | 713664 | 4.3% |
| 9 | 705946 | 4.3% |
| Other values (2) | 746736 | 4.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 16567610 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| : | 3313522 | |
| 1 | 3098589 | |
| 0 | 2406481 | |
| 2 | 1531188 | |
| 5 | 1257575 | 7.6% |
| 3 | 1042379 | 6.3% |
| 4 | 1018773 | 6.1% |
| 6 | 732757 | 4.4% |
| 8 | 713664 | 4.3% |
| 9 | 705946 | 4.3% |
| Other values (2) | 746736 | 4.5% |
DEP_DELAY
Real number (ℝ)
Missing  Zeros 
| Distinct | 608 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 77821 |
| Missing (%) | 2.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.725938 |
| Minimum | -52 |
|---|---|
| Maximum | 975 |
| Zeros | 215759 |
| Zeros (%) | 6.5% |
| Negative | 1251237 |
| Negative (%) | 37.8% |
| Memory size | 50.6 MiB |
Quantile statistics
| Minimum | -52 |
|---|---|
| 5-th percentile | -6 |
| Q1 | -3 |
| median | 2 |
| Q3 | 17 |
| 95-th percentile | 70 |
| Maximum | 975 |
| Range | 1027 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 32.522796 |
|---|---|
| Coefficient of variation (CV) | 2.3694407 |
| Kurtosis | 28.696176 |
| Mean | 13.725938 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 4.2815144 |
| Sum | 44413031 |
| Variance | 1057.7322 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 215759 | 6.5% |
| -1 | 215140 | 6.5% |
| -2 | 208355 | 6.3% |
| -3 | 201246 | 6.1% |
| -4 | 185233 | 5.6% |
| -5 | 182883 | 5.5% |
| 1 | 115130 | 3.5% |
| -6 | 110519 | 3.3% |
| 2 | 93100 | 2.8% |
| 3 | 81586 | 2.5% |
| Other values (598) | 1626750 | |
| (Missing) | 77821 | 2.3% |
| Value | Count | Frequency (%) |
| -52 | 1 | < 0.1% |
| -38 | 1 | < 0.1% |
| -31 | 1 | < 0.1% |
| -30 | 1 | < 0.1% |
| -29 | 2 | < 0.1% |
| -28 | 1 | < 0.1% |
| -27 | 1 | < 0.1% |
| -26 | 2 | < 0.1% |
| -25 | 5 | |
| -24 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 975 | 1 | |
| 775 | 1 | |
| 747 | 1 | |
| 726 | 1 | |
| 721 | 1 | |
| 705 | 1 | |
| 702 | 1 | |
| 681 | 1 | |
| 669 | 1 | |
| 648 | 1 |
TAXI_OUT
Real number (ℝ)
Missing 
| Distinct | 172 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 78301 |
| Missing (%) | 2.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.563544 |
| Minimum | 1 |
|---|---|
| Maximum | 174 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 50.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 9 |
| median | 11 |
| Q3 | 14 |
| 95-th percentile | 23 |
| Maximum | 174 |
| Range | 173 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 6.3453344 |
|---|---|
| Coefficient of variation (CV) | 0.50505926 |
| Kurtosis | 47.26845 |
| Mean | 12.563544 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 4.7310257 |
| Sum | 40645843 |
| Variance | 40.263269 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 406149 | |
| 9 | 393799 | |
| 11 | 367951 | |
| 8 | 318094 | |
| 12 | 305346 | |
| 13 | 241126 | |
| 7 | 192917 | 5.8% |
| 14 | 186709 | 5.6% |
| 15 | 143818 | 4.3% |
| 16 | 110283 | 3.3% |
| Other values (162) | 569029 |
| Value | Count | Frequency (%) |
| 1 | 99 | < 0.1% |
| 2 | 177 | < 0.1% |
| 3 | 283 | < 0.1% |
| 4 | 761 | < 0.1% |
| 5 | 12536 | 0.4% |
| 6 | 74515 | 2.2% |
| 7 | 192917 | |
| 8 | 318094 | |
| 9 | 393799 | |
| 10 | 406149 |
| Value | Count | Frequency (%) |
| 174 | 1 | |
| 172 | 2 | |
| 171 | 1 | |
| 170 | 2 | |
| 169 | 1 | |
| 168 | 1 | |
| 167 | 1 | |
| 166 | 1 | |
| 164 | 1 | |
| 163 | 1 |
WHEELS_OFF
Text
| Distinct | 1374 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 MiB |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 29 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 13:02 |
|---|---|
| 2nd row | 16:53 |
| 3rd row | 12:06 |
| 4th row | 17:42 |
| 5th row | 20:36 |
| Value | Count | Frequency (%) |
| 0:01 | 78301 | 2.4% |
| 06:10 | 4930 | 0.1% |
| 06:11 | 4911 | 0.1% |
| 06:14 | 4881 | 0.1% |
| 06:12 | 4857 | 0.1% |
| 06:13 | 4823 | 0.1% |
| 06:16 | 4782 | 0.1% |
| 06:17 | 4762 | 0.1% |
| 06:18 | 4753 | 0.1% |
| 06:15 | 4698 | 0.1% |
| Other values (1364) | 3191824 |
Most occurring characters
| Value | Count | Frequency (%) |
| : | 3313522 | |
| 1 | 3169534 | |
| 0 | 2320647 | |
| 2 | 1599738 | |
| 5 | 1117573 | 6.7% |
| 3 | 1087766 | 6.6% |
| 4 | 1028327 | 6.2% |
| 6 | 740949 | 4.5% |
| 8 | 712781 | 4.3% |
| 9 | 704593 | 4.3% |
| Other values (2) | 772180 | 4.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 16567610 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| : | 3313522 | |
| 1 | 3169534 | |
| 0 | 2320647 | |
| 2 | 1599738 | |
| 5 | 1117573 | 6.7% |
| 3 | 1087766 | 6.6% |
| 4 | 1028327 | 6.2% |
| 6 | 740949 | 4.5% |
| 8 | 712781 | 4.3% |
| 9 | 704593 | 4.3% |
| Other values (2) | 772180 | 4.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 16567610 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| : | 3313522 | |
| 1 | 3169534 | |
| 0 | 2320647 | |
| 2 | 1599738 | |
| 5 | 1117573 | 6.7% |
| 3 | 1087766 | 6.6% |
| 4 | 1028327 | 6.2% |
| 6 | 740949 | 4.5% |
| 8 | 712781 | 4.3% |
| 9 | 704593 | 4.3% |
| Other values (2) | 772180 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 16567610 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| : | 3313522 | |
| 1 | 3169534 | |
| 0 | 2320647 | |
| 2 | 1599738 | |
| 5 | 1117573 | 6.7% |
| 3 | 1087766 | 6.6% |
| 4 | 1028327 | 6.2% |
| 6 | 740949 | 4.5% |
| 8 | 712781 | 4.3% |
| 9 | 704593 | 4.3% |
| Other values (2) | 772180 | 4.7% |
WHEELS_ON
Text
| Distinct | 1440 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 MiB |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 13:41 |
|---|---|
| 2nd row | 17:39 |
| 3rd row | 13:21 |
| 4th row | 19:04 |
| 5th row | 22:07 |
| Value | Count | Frequency (%) |
| 0:01 | 79338 | 2.4% |
| 09:38 | 3603 | 0.1% |
| 09:44 | 3564 | 0.1% |
| 09:36 | 3559 | 0.1% |
| 18:18 | 3556 | 0.1% |
| 09:56 | 3530 | 0.1% |
| 09:42 | 3530 | 0.1% |
| 09:45 | 3521 | 0.1% |
| 09:54 | 3511 | 0.1% |
| 09:47 | 3506 | 0.1% |
| Other values (1430) | 3202304 |
Most occurring characters
| Value | Count | Frequency (%) |
| : | 3313522 | |
| 1 | 3190273 | |
| 0 | 2195143 | |
| 2 | 1881918 | |
| 3 | 1173911 | 7.1% |
| 5 | 1054817 | 6.4% |
| 4 | 1039696 | 6.3% |
| 9 | 708821 | 4.3% |
| 8 | 677774 | 4.1% |
| 7 | 672855 | 4.1% |
| Other values (2) | 658880 | 4.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 16567610 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| : | 3313522 | |
| 1 | 3190273 | |
| 0 | 2195143 | |
| 2 | 1881918 | |
| 3 | 1173911 | 7.1% |
| 5 | 1054817 | 6.4% |
| 4 | 1039696 | 6.3% |
| 9 | 708821 | 4.3% |
| 8 | 677774 | 4.1% |
| 7 | 672855 | 4.1% |
| Other values (2) | 658880 | 4.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 16567610 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| : | 3313522 | |
| 1 | 3190273 | |
| 0 | 2195143 | |
| 2 | 1881918 | |
| 3 | 1173911 | 7.1% |
| 5 | 1054817 | 6.4% |
| 4 | 1039696 | 6.3% |
| 9 | 708821 | 4.3% |
| 8 | 677774 | 4.1% |
| 7 | 672855 | 4.1% |
| Other values (2) | 658880 | 4.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 16567610 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| : | 3313522 | |
| 1 | 3190273 | |
| 0 | 2195143 | |
| 2 | 1881918 | |
| 3 | 1173911 | 7.1% |
| 5 | 1054817 | 6.4% |
| 4 | 1039696 | 6.3% |
| 9 | 708821 | 4.3% |
| 8 | 677774 | 4.1% |
| 7 | 672855 | 4.1% |
| Other values (2) | 658880 | 4.0% |
TAXI_IN
Real number (ℝ)
Missing 
| Distinct | 176 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 79338 |
| Missing (%) | 2.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.8249605 |
| Minimum | 1 |
|---|---|
| Maximum | 186 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 50.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 14 |
| Maximum | 186 |
| Range | 185 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 5.3994704 |
|---|---|
| Coefficient of variation (CV) | 0.92695399 |
| Kurtosis | 74.307258 |
| Mean | 5.8249605 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 6.2332929 |
| Sum | 18838994 |
| Variance | 29.154281 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 764035 | |
| 3 | 630229 | |
| 5 | 555434 | |
| 6 | 352104 | |
| 2 | 210043 | 6.3% |
| 7 | 208729 | 6.3% |
| 8 | 122135 | 3.7% |
| 9 | 74515 | 2.2% |
| 10 | 49264 | 1.5% |
| 11 | 34711 | 1.0% |
| Other values (166) | 232985 | 7.0% |
| (Missing) | 79338 | 2.4% |
| Value | Count | Frequency (%) |
| 1 | 17277 | 0.5% |
| 2 | 210043 | 6.3% |
| 3 | 630229 | |
| 4 | 764035 | |
| 5 | 555434 | |
| 6 | 352104 | |
| 7 | 208729 | 6.3% |
| 8 | 122135 | 3.7% |
| 9 | 74515 | 2.2% |
| 10 | 49264 | 1.5% |
| Value | Count | Frequency (%) |
| 186 | 1 | < 0.1% |
| 184 | 1 | < 0.1% |
| 181 | 1 | < 0.1% |
| 180 | 1 | < 0.1% |
| 177 | 1 | < 0.1% |
| 176 | 4 | |
| 175 | 6 | |
| 172 | 1 | < 0.1% |
| 171 | 1 | < 0.1% |
| 170 | 1 | < 0.1% |
CRS_ARR_TIME
Date
| Distinct | 239 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 MiB |
| Minimum | 2024-10-18 00:05:00 |
|---|---|
| Maximum | 2024-10-18 23:55:00 |
ARR_TIME
Text
| Distinct | 1440 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 MiB |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 13:47 |
|---|---|
| 2nd row | 17:48 |
| 3rd row | 13:31 |
| 4th row | 19:28 |
| 5th row | 22:14 |
| Value | Count | Frequency (%) |
| 0:01 | 79323 | 2.4% |
| 18:01 | 3561 | 0.1% |
| 09:45 | 3534 | 0.1% |
| 18:40 | 3532 | 0.1% |
| 09:50 | 3530 | 0.1% |
| 09:46 | 3524 | 0.1% |
| 09:43 | 3517 | 0.1% |
| 09:44 | 3516 | 0.1% |
| 09:40 | 3515 | 0.1% |
| 09:38 | 3514 | 0.1% |
| Other values (1430) | 3202456 |
Most occurring characters
| Value | Count | Frequency (%) |
| : | 3313522 | |
| 1 | 3194427 | |
| 0 | 2196383 | |
| 2 | 1899189 | |
| 3 | 1177806 | 7.1% |
| 5 | 1051251 | 6.3% |
| 4 | 1037880 | 6.3% |
| 9 | 705139 | 4.3% |
| 8 | 676822 | 4.1% |
| 7 | 668145 | 4.0% |
| Other values (2) | 647046 | 3.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 16567610 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| : | 3313522 | |
| 1 | 3194427 | |
| 0 | 2196383 | |
| 2 | 1899189 | |
| 3 | 1177806 | 7.1% |
| 5 | 1051251 | 6.3% |
| 4 | 1037880 | 6.3% |
| 9 | 705139 | 4.3% |
| 8 | 676822 | 4.1% |
| 7 | 668145 | 4.0% |
| Other values (2) | 647046 | 3.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 16567610 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| : | 3313522 | |
| 1 | 3194427 | |
| 0 | 2196383 | |
| 2 | 1899189 | |
| 3 | 1177806 | 7.1% |
| 5 | 1051251 | 6.3% |
| 4 | 1037880 | 6.3% |
| 9 | 705139 | 4.3% |
| 8 | 676822 | 4.1% |
| 7 | 668145 | 4.0% |
| Other values (2) | 647046 | 3.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 16567610 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| : | 3313522 | |
| 1 | 3194427 | |
| 0 | 2196383 | |
| 2 | 1899189 | |
| 3 | 1177806 | 7.1% |
| 5 | 1051251 | 6.3% |
| 4 | 1037880 | 6.3% |
| 9 | 705139 | 4.3% |
| 8 | 676822 | 4.1% |
| 7 | 668145 | 4.0% |
| Other values (2) | 647046 | 3.9% |
ARR_DELAY
Real number (ℝ)
Missing  Zeros 
| Distinct | 638 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 85785 |
| Missing (%) | 2.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.746238 |
| Minimum | -71 |
|---|---|
| Maximum | 812 |
| Zeros | 66616 |
| Zeros (%) | 2.0% |
| Negative | 1791298 |
| Negative (%) | 54.1% |
| Memory size | 50.6 MiB |
Quantile statistics
| Minimum | -71 |
|---|---|
| 5-th percentile | -22 |
| Q1 | -12 |
| median | -3 |
| Q3 | 13 |
| 95-th percentile | 68 |
| Maximum | 812 |
| Range | 883 |
| Interquartile range (IQR) | 25 |
Descriptive statistics
| Standard deviation | 34.84579 |
|---|---|
| Coefficient of variation (CV) | 5.1652179 |
| Kurtosis | 22.973001 |
| Mean | 6.746238 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 3.7090012 |
| Sum | 21775082 |
| Variance | 1214.229 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -10 | 94898 | 2.9% |
| -9 | 94426 | 2.8% |
| -8 | 94154 | 2.8% |
| -11 | 93877 | 2.8% |
| -7 | 91496 | 2.8% |
| -12 | 90985 | 2.7% |
| -13 | 88535 | 2.7% |
| -6 | 88268 | 2.7% |
| -5 | 85289 | 2.6% |
| -14 | 83572 | 2.5% |
| Other values (628) | 2322237 | |
| (Missing) | 85785 | 2.6% |
| Value | Count | Frequency (%) |
| -71 | 1 | < 0.1% |
| -69 | 3 | < 0.1% |
| -68 | 2 | < 0.1% |
| -67 | 1 | < 0.1% |
| -66 | 5 | |
| -65 | 3 | < 0.1% |
| -64 | 5 | |
| -63 | 6 | |
| -62 | 6 | |
| -61 | 10 |
| Value | Count | Frequency (%) |
| 812 | 1 | |
| 810 | 1 | |
| 760 | 1 | |
| 731 | 1 | |
| 714 | 1 | |
| 697 | 1 | |
| 691 | 1 | |
| 667 | 1 | |
| 655 | 1 | |
| 652 | 1 |
CANCELLED
Categorical
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 MiB |
| 0.0 | |
|---|---|
| 1.0 | 78488 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 3235034 | |
| 1.0 | 78488 | 2.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 3235034 | |
| 1.0 | 78488 | 2.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 6548556 | |
| . | 3313522 | |
| 1 | 78488 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9940566 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6548556 | |
| . | 3313522 | |
| 1 | 78488 | 0.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9940566 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6548556 | |
| . | 3313522 | |
| 1 | 78488 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9940566 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6548556 | |
| . | 3313522 | |
| 1 | 78488 | 0.8% |
CANCELLATION_CODE
Categorical
Missing 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3235034 |
| Missing (%) | 97.6% |
| Memory size | 50.6 MiB |
| B | |
|---|---|
| A | |
| C | |
| D | 114 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | B |
|---|---|
| 2nd row | B |
| 3rd row | B |
| 4th row | B |
| 5th row | B |
Common Values
| Value | Count | Frequency (%) |
| B | 39025 | 1.2% |
| A | 33718 | 1.0% |
| C | 5631 | 0.2% |
| D | 114 | < 0.1% |
| (Missing) | 3235034 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| b | 39025 | |
| a | 33718 | |
| c | 5631 | 7.2% |
| d | 114 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 39025 | |
| A | 33718 | |
| C | 5631 | 7.2% |
| D | 114 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 78488 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| B | 39025 | |
| A | 33718 | |
| C | 5631 | 7.2% |
| D | 114 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 78488 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| B | 39025 | |
| A | 33718 | |
| C | 5631 | 7.2% |
| D | 114 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 78488 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| B | 39025 | |
| A | 33718 | |
| C | 5631 | 7.2% |
| D | 114 | 0.1% |
DIVERTED
Categorical
Imbalance 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 50.6 MiB |
| 0.0 | |
|---|---|
| 1.0 | 7297 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 3306225 | |
| 1.0 | 7297 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 3306225 | |
| 1.0 | 7297 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 6619747 | |
| . | 3313522 | |
| 1 | 7297 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9940566 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6619747 | |
| . | 3313522 | |
| 1 | 7297 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9940566 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6619747 | |
| . | 3313522 | |
| 1 | 7297 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9940566 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 6619747 | |
| . | 3313522 | |
| 1 | 7297 | 0.1% |
CRS_ELAPSED_TIME
Real number (ℝ)
| Distinct | 84 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 127.81859 |
| Minimum | 35 |
|---|---|
| Maximum | 480 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 50.6 MiB |
Quantile statistics
| Minimum | 35 |
|---|---|
| 5-th percentile | 65 |
| Q1 | 85 |
| median | 115 |
| Q3 | 155 |
| 95-th percentile | 240 |
| Maximum | 480 |
| Range | 445 |
| Interquartile range (IQR) | 70 |
Descriptive statistics
| Standard deviation | 56.677458 |
|---|---|
| Coefficient of variation (CV) | 0.44342107 |
| Kurtosis | 2.3429717 |
| Mean | 127.81859 |
| Median Absolute Deviation (MAD) | 35 |
| Skewness | 1.3418643 |
| Sum | 4.2352973 × 108 |
| Variance | 3212.3343 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 85 | 205990 | 6.2% |
| 90 | 186734 | 5.6% |
| 80 | 177522 | 5.4% |
| 70 | 164351 | 5.0% |
| 75 | 159795 | 4.8% |
| 95 | 121134 | 3.7% |
| 135 | 117920 | 3.6% |
| 65 | 116020 | 3.5% |
| 110 | 115612 | 3.5% |
| 140 | 112193 | 3.4% |
| Other values (74) | 1836251 |
| Value | Count | Frequency (%) |
| 35 | 3861 | 0.1% |
| 40 | 10156 | 0.3% |
| 45 | 17613 | 0.5% |
| 50 | 15092 | 0.5% |
| 55 | 26486 | 0.8% |
| 60 | 52045 | 1.6% |
| 65 | 116020 | |
| 70 | 164351 | |
| 75 | 159795 | |
| 80 | 177522 |
| Value | Count | Frequency (%) |
| 480 | 1 | < 0.1% |
| 425 | 47 | < 0.1% |
| 420 | 34 | < 0.1% |
| 415 | 117 | < 0.1% |
| 410 | 144 | < 0.1% |
| 405 | 423 | |
| 400 | 372 | < 0.1% |
| 395 | 465 | |
| 390 | 683 | |
| 385 | 1012 |
ELAPSED_TIME
Real number (ℝ)
Missing 
| Distinct | 445 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 85785 |
| Missing (%) | 2.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 120.89473 |
| Minimum | 22 |
|---|---|
| Maximum | 524 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 50.6 MiB |
Quantile statistics
| Minimum | 22 |
|---|---|
| 5-th percentile | 56 |
| Q1 | 78 |
| median | 109 |
| Q3 | 149 |
| 95-th percentile | 231 |
| Maximum | 524 |
| Range | 502 |
| Interquartile range (IQR) | 71 |
Descriptive statistics
| Standard deviation | 56.913093 |
|---|---|
| Coefficient of variation (CV) | 0.47076572 |
| Kurtosis | 2.3242189 |
| Mean | 120.89473 |
| Median Absolute Deviation (MAD) | 34 |
| Skewness | 1.3345112 |
| Sum | 3.9021638 × 108 |
| Variance | 3239.1002 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 77 | 36240 | 1.1% |
| 76 | 36078 | 1.1% |
| 79 | 35957 | 1.1% |
| 78 | 35937 | 1.1% |
| 75 | 35770 | 1.1% |
| 80 | 35119 | 1.1% |
| 74 | 35094 | 1.1% |
| 81 | 34326 | 1.0% |
| 73 | 34318 | 1.0% |
| 82 | 33606 | 1.0% |
| Other values (435) | 2875292 | |
| (Missing) | 85785 | 2.6% |
| Value | Count | Frequency (%) |
| 22 | 1 | < 0.1% |
| 23 | 1 | < 0.1% |
| 25 | 6 | < 0.1% |
| 26 | 10 | < 0.1% |
| 27 | 53 | < 0.1% |
| 28 | 129 | < 0.1% |
| 29 | 266 | < 0.1% |
| 30 | 473 | |
| 31 | 782 | |
| 32 | 1074 |
| Value | Count | Frequency (%) |
| 524 | 1 | |
| 519 | 1 | |
| 494 | 1 | |
| 491 | 1 | |
| 488 | 2 | |
| 481 | 1 | |
| 477 | 1 | |
| 474 | 1 | |
| 473 | 1 | |
| 470 | 1 |
AIR_TIME
Real number (ℝ)
Missing 
| Distinct | 410 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 85785 |
| Missing (%) | 2.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 102.51606 |
| Minimum | 12 |
|---|---|
| Maximum | 503 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 50.6 MiB |
Quantile statistics
| Minimum | 12 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 60 |
| median | 91 |
| Q3 | 130 |
| 95-th percentile | 210 |
| Maximum | 503 |
| Range | 491 |
| Interquartile range (IQR) | 70 |
Descriptive statistics
| Standard deviation | 55.640874 |
|---|---|
| Coefficient of variation (CV) | 0.54275273 |
| Kurtosis | 2.4592845 |
| Mean | 102.51606 |
| Median Absolute Deviation (MAD) | 33 |
| Skewness | 1.3751223 |
| Sum | 3.308949 × 108 |
| Variance | 3095.9068 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 62 | 39494 | 1.2% |
| 63 | 38843 | 1.2% |
| 61 | 38754 | 1.2% |
| 64 | 38208 | 1.2% |
| 60 | 37843 | 1.1% |
| 59 | 36680 | 1.1% |
| 65 | 36485 | 1.1% |
| 58 | 35868 | 1.1% |
| 66 | 35478 | 1.1% |
| 57 | 35184 | 1.1% |
| Other values (400) | 2854900 | |
| (Missing) | 85785 | 2.6% |
| Value | Count | Frequency (%) |
| 12 | 1 | < 0.1% |
| 13 | 9 | < 0.1% |
| 14 | 84 | < 0.1% |
| 15 | 211 | < 0.1% |
| 16 | 534 | < 0.1% |
| 17 | 776 | < 0.1% |
| 18 | 943 | < 0.1% |
| 19 | 1418 | < 0.1% |
| 20 | 2331 | |
| 21 | 4163 |
| Value | Count | Frequency (%) |
| 503 | 1 | < 0.1% |
| 434 | 1 | < 0.1% |
| 433 | 1 | < 0.1% |
| 422 | 1 | < 0.1% |
| 419 | 3 | |
| 418 | 1 | < 0.1% |
| 416 | 1 | < 0.1% |
| 415 | 1 | < 0.1% |
| 413 | 2 | |
| 412 | 3 |
DISTANCE
Real number (ℝ)
| Distinct | 730 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 739.96997 |
| Minimum | 73 |
|---|---|
| Maximum | 2979 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 50.6 MiB |
Quantile statistics
| Minimum | 73 |
|---|---|
| 5-th percentile | 223 |
| Q1 | 387 |
| median | 641 |
| Q3 | 967 |
| 95-th percentile | 1620 |
| Maximum | 2979 |
| Range | 2906 |
| Interquartile range (IQR) | 580 |
Descriptive statistics
| Standard deviation | 464.34376 |
|---|---|
| Coefficient of variation (CV) | 0.62751703 |
| Kurtosis | 2.6530514 |
| Mean | 739.96997 |
| Median Absolute Deviation (MAD) | 279 |
| Skewness | 1.4094771 |
| Sum | 2.4519068 × 109 |
| Variance | 215615.13 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 337 | 28881 | 0.9% |
| 325 | 25119 | 0.8% |
| 480 | 24667 | 0.7% |
| 602 | 24529 | 0.7% |
| 255 | 23348 | 0.7% |
| 417 | 22670 | 0.7% |
| 296 | 22470 | 0.7% |
| 369 | 22019 | 0.7% |
| 651 | 21531 | 0.6% |
| 404 | 20374 | 0.6% |
| Other values (720) | 3077914 |
| Value | Count | Frequency (%) |
| 73 | 6802 | |
| 84 | 2310 | 0.1% |
| 100 | 15358 | |
| 102 | 9225 | |
| 133 | 1990 | 0.1% |
| 137 | 4918 | 0.1% |
| 141 | 3177 | 0.1% |
| 148 | 8579 | |
| 153 | 3818 | 0.1% |
| 159 | 7241 |
| Value | Count | Frequency (%) |
| 2979 | 232 | < 0.1% |
| 2917 | 1846 | |
| 2860 | 310 | < 0.1% |
| 2845 | 1592 | |
| 2818 | 1216 | |
| 2762 | 2568 | |
| 2717 | 1137 | |
| 2695 | 2273 | |
| 2676 | 486 | < 0.1% |
| 2615 | 1224 |
DELAY_DUE_CARRIER
Real number (ℝ)
Missing  Zeros 
| Distinct | 512 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2553684 |
| Missing (%) | 77.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.178392 |
| Minimum | 0 |
|---|---|
| Maximum | 741 |
| Zeros | 243307 |
| Zeros (%) | 7.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 50.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 8 |
| Q3 | 20 |
| 95-th percentile | 68 |
| Maximum | 741 |
| Range | 741 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 31.1235 |
|---|---|
| Coefficient of variation (CV) | 1.8117819 |
| Kurtosis | 37.455361 |
| Mean | 17.178392 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 4.8687856 |
| Sum | 13052795 |
| Variance | 968.67227 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 243307 | 7.3% |
| 6 | 20618 | 0.6% |
| 7 | 20081 | 0.6% |
| 8 | 18746 | 0.6% |
| 4 | 18683 | 0.6% |
| 3 | 18667 | 0.6% |
| 2 | 18566 | 0.6% |
| 5 | 18482 | 0.6% |
| 9 | 17882 | 0.5% |
| 1 | 17826 | 0.5% |
| Other values (502) | 346980 | 10.5% |
| (Missing) | 2553684 |
| Value | Count | Frequency (%) |
| 0 | 243307 | |
| 1 | 17826 | 0.5% |
| 2 | 18566 | 0.6% |
| 3 | 18667 | 0.6% |
| 4 | 18683 | 0.6% |
| 5 | 18482 | 0.6% |
| 6 | 20618 | 0.6% |
| 7 | 20081 | 0.6% |
| 8 | 18746 | 0.6% |
| 9 | 17882 | 0.5% |
| Value | Count | Frequency (%) |
| 741 | 1 | |
| 690 | 1 | |
| 667 | 1 | |
| 648 | 1 | |
| 612 | 1 | |
| 606 | 1 | |
| 588 | 1 | |
| 586 | 1 | |
| 577 | 1 | |
| 575 | 1 |
DELAY_DUE_WEATHER
Real number (ℝ)
Missing  Zeros 
| Distinct | 391 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2553684 |
| Missing (%) | 77.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1075506 |
| Minimum | 0 |
|---|---|
| Maximum | 726 |
| Zeros | 744337 |
| Zeros (%) | 22.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 50.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 726 |
| Range | 726 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 11.316744 |
|---|---|
| Coefficient of variation (CV) | 10.217813 |
| Kurtosis | 452.44609 |
| Mean | 1.1075506 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 17.654631 |
| Sum | 841559 |
| Variance | 128.0687 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 744337 | 22.5% |
| 15 | 309 | < 0.1% |
| 17 | 305 | < 0.1% |
| 19 | 298 | < 0.1% |
| 16 | 295 | < 0.1% |
| 14 | 290 | < 0.1% |
| 20 | 290 | < 0.1% |
| 18 | 280 | < 0.1% |
| 12 | 278 | < 0.1% |
| 10 | 249 | < 0.1% |
| Other values (381) | 12907 | 0.4% |
| (Missing) | 2553684 |
| Value | Count | Frequency (%) |
| 0 | 744337 | |
| 1 | 83 | < 0.1% |
| 2 | 122 | < 0.1% |
| 3 | 118 | < 0.1% |
| 4 | 147 | < 0.1% |
| 5 | 191 | < 0.1% |
| 6 | 223 | < 0.1% |
| 7 | 219 | < 0.1% |
| 8 | 218 | < 0.1% |
| 9 | 245 | < 0.1% |
| Value | Count | Frequency (%) |
| 726 | 1 | |
| 702 | 1 | |
| 618 | 1 | |
| 581 | 1 | |
| 577 | 1 | |
| 571 | 1 | |
| 530 | 1 | |
| 526 | 1 | |
| 514 | 1 | |
| 510 | 1 |
DELAY_DUE_NAS
Real number (ℝ)
Missing  Zeros 
| Distinct | 402 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2553684 |
| Missing (%) | 77.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.5263359 |
| Minimum | 0 |
|---|---|
| Maximum | 731 |
| Zeros | 470725 |
| Zeros (%) | 14.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 50.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 7 |
| 95-th percentile | 35 |
| Maximum | 731 |
| Range | 731 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 19.26359 |
|---|---|
| Coefficient of variation (CV) | 2.5594911 |
| Kurtosis | 70.546487 |
| Mean | 7.5263359 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.4551743 |
| Sum | 5718796 |
| Variance | 371.08589 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 470725 | 14.2% |
| 1 | 18657 | 0.6% |
| 2 | 17245 | 0.5% |
| 3 | 15357 | 0.5% |
| 4 | 14252 | 0.4% |
| 5 | 13201 | 0.4% |
| 6 | 11908 | 0.4% |
| 7 | 11020 | 0.3% |
| 15 | 10216 | 0.3% |
| 8 | 10149 | 0.3% |
| Other values (392) | 167108 | 5.0% |
| (Missing) | 2553684 |
| Value | Count | Frequency (%) |
| 0 | 470725 | |
| 1 | 18657 | 0.6% |
| 2 | 17245 | 0.5% |
| 3 | 15357 | 0.5% |
| 4 | 14252 | 0.4% |
| 5 | 13201 | 0.4% |
| 6 | 11908 | 0.4% |
| 7 | 11020 | 0.3% |
| 8 | 10149 | 0.3% |
| 9 | 9281 | 0.3% |
| Value | Count | Frequency (%) |
| 731 | 1 | |
| 586 | 1 | |
| 522 | 1 | |
| 517 | 1 | |
| 515 | 1 | |
| 500 | 1 | |
| 486 | 1 | |
| 485 | 1 | |
| 479 | 1 | |
| 477 | 1 |
DELAY_DUE_SECURITY
Real number (ℝ)
Missing  Skewed  Zeros 
| Distinct | 197 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2553684 |
| Missing (%) | 77.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1449151 |
| Minimum | 0 |
|---|---|
| Maximum | 581 |
| Zeros | 756232 |
| Zeros (%) | 22.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 50.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 581 |
| Range | 581 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.284715 |
|---|---|
| Coefficient of variation (CV) | 22.666478 |
| Kurtosis | 4098.7235 |
| Mean | 0.1449151 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 49.641986 |
| Sum | 110112 |
| Variance | 10.789352 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 756232 | 22.8% |
| 16 | 176 | < 0.1% |
| 15 | 170 | < 0.1% |
| 17 | 139 | < 0.1% |
| 18 | 133 | < 0.1% |
| 19 | 113 | < 0.1% |
| 20 | 113 | < 0.1% |
| 12 | 112 | < 0.1% |
| 14 | 103 | < 0.1% |
| 21 | 103 | < 0.1% |
| Other values (187) | 2444 | 0.1% |
| (Missing) | 2553684 |
| Value | Count | Frequency (%) |
| 0 | 756232 | |
| 1 | 36 | < 0.1% |
| 2 | 45 | < 0.1% |
| 3 | 49 | < 0.1% |
| 4 | 36 | < 0.1% |
| 5 | 58 | < 0.1% |
| 6 | 79 | < 0.1% |
| 7 | 95 | < 0.1% |
| 8 | 80 | < 0.1% |
| 9 | 88 | < 0.1% |
| Value | Count | Frequency (%) |
| 581 | 1 | |
| 454 | 1 | |
| 415 | 1 | |
| 332 | 1 | |
| 308 | 1 | |
| 305 | 1 | |
| 300 | 1 | |
| 290 | 1 | |
| 278 | 1 | |
| 246 | 1 |
DELAY_DUE_LATE_AIRCRAFT
Real number (ℝ)
Missing  Zeros 
| Distinct | 461 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2553684 |
| Missing (%) | 77.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.346619 |
| Minimum | 0 |
|---|---|
| Maximum | 636 |
| Zeros | 232743 |
| Zeros (%) | 7.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 50.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 14 |
| Q3 | 33 |
| 95-th percentile | 98 |
| Maximum | 636 |
| Range | 636 |
| Interquartile range (IQR) | 33 |
Descriptive statistics
| Standard deviation | 37.815797 |
|---|---|
| Coefficient of variation (CV) | 1.4919464 |
| Kurtosis | 14.563172 |
| Mean | 25.346619 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 3.1338536 |
| Sum | 19259324 |
| Variance | 1430.0345 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 232743 | 7.0% |
| 15 | 15020 | 0.5% |
| 16 | 14359 | 0.4% |
| 17 | 13616 | 0.4% |
| 18 | 12878 | 0.4% |
| 14 | 12289 | 0.4% |
| 19 | 12063 | 0.4% |
| 13 | 12003 | 0.4% |
| 12 | 11694 | 0.4% |
| 11 | 11603 | 0.4% |
| Other values (451) | 411570 | 12.4% |
| (Missing) | 2553684 |
| Value | Count | Frequency (%) |
| 0 | 232743 | |
| 1 | 10957 | 0.3% |
| 2 | 11014 | 0.3% |
| 3 | 10134 | 0.3% |
| 4 | 9637 | 0.3% |
| 5 | 9937 | 0.3% |
| 6 | 10669 | 0.3% |
| 7 | 10475 | 0.3% |
| 8 | 10892 | 0.3% |
| 9 | 11049 | 0.3% |
| Value | Count | Frequency (%) |
| 636 | 1 | |
| 615 | 1 | |
| 606 | 1 | |
| 558 | 1 | |
| 556 | 1 | |
| 551 | 1 | |
| 531 | 1 | |
| 511 | 1 | |
| 507 | 1 | |
| 504 | 1 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2021 |
|---|---|
| 2nd row | 2021 |
| 3rd row | 2021 |
| 4th row | 2021 |
| 5th row | 2021 |
Common Values
| Value | Count | Frequency (%) |
| 2022 | 1307149 | |
| 2021 | 1064640 | |
| 2023 | 941733 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2022 | 1307149 | |
| 2021 | 1064640 | |
| 2023 | 941733 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 7934193 | |
| 0 | 3313522 | |
| 1 | 1064640 | 8.0% |
| 3 | 941733 | 7.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 13254088 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 7934193 | |
| 0 | 3313522 | |
| 1 | 1064640 | 8.0% |
| 3 | 941733 | 7.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 13254088 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 7934193 | |
| 0 | 3313522 | |
| 1 | 1064640 | 8.0% |
| 3 | 941733 | 7.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 13254088 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 7934193 | |
| 0 | 3313522 | |
| 1 | 1064640 | 8.0% |
| 3 | 941733 | 7.1% |
MONTH
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.2173159 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 37.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.2422985 |
|---|---|
| Coefficient of variation (CV) | 0.52149489 |
| Kurtosis | -1.011994 |
| Mean | 6.2173159 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.10514414 |
| Sum | 20601213 |
| Variance | 10.5125 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 349077 | |
| 7 | 348269 | |
| 6 | 328785 | |
| 5 | 317834 | |
| 3 | 302291 | |
| 4 | 299130 | |
| 1 | 271173 | |
| 2 | 245153 | |
| 10 | 219820 | |
| 12 | 213568 | |
| Other values (2) | 418422 |
| Value | Count | Frequency (%) |
| 1 | 271173 | |
| 2 | 245153 | |
| 3 | 302291 | |
| 4 | 299130 | |
| 5 | 317834 | |
| 6 | 328785 | |
| 7 | 348269 | |
| 8 | 349077 | |
| 9 | 209848 | |
| 10 | 219820 |
| Value | Count | Frequency (%) |
| 12 | 213568 | |
| 11 | 208574 | |
| 10 | 219820 | |
| 9 | 209848 | |
| 8 | 349077 | |
| 7 | 348269 | |
| 6 | 328785 | |
| 5 | 317834 | |
| 4 | 299130 | |
| 3 | 302291 |
Interactions
Missing values
Sample
| FL_DATE | AIRLINE | AIRLINE_DOT | AIRLINE_CODE | DOT_CODE | FL_NUMBER | ORIGIN | ORIGIN_CITY | DEST | DEST_CITY | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | WHEELS_OFF | WHEELS_ON | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | CRS_ELAPSED_TIME | ELAPSED_TIME | AIR_TIME | DISTANCE | DELAY_DUE_CARRIER | DELAY_DUE_WEATHER | DELAY_DUE_NAS | DELAY_DUE_SECURITY | DELAY_DUE_LATE_AIRCRAFT | YEAR | MONTH | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 106 | 2021-01-01 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 2527 | BWI | Baltimore, MD | BNA | Nashville, TN | 12:55 | 12:53 | -2.0 | 9.0 | 13:02 | 13:41 | 6.0 | 13:55 | 13:47 | -8.0 | 0.0 | NaN | 0.0 | 120.0 | 114.0 | 99.0 | 587.0 | NaN | NaN | NaN | NaN | NaN | 2021 | 1 |
| 1364 | 2021-01-01 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 1782 | ATL | Atlanta, GA | MCI | Kansas City, MO | 16:35 | 16:41 | 6.0 | 12.0 | 16:53 | 17:39 | 9.0 | 17:50 | 17:48 | -2.0 | 0.0 | NaN | 0.0 | 135.0 | 127.0 | 106.0 | 692.0 | NaN | NaN | NaN | NaN | NaN | 2021 | 1 |
| 1365 | 2021-01-01 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 2003 | ATL | Atlanta, GA | BWI | Baltimore, MD | 12:00 | 11:58 | -2.0 | 8.0 | 12:06 | 13:21 | 10.0 | 13:45 | 13:31 | -14.0 | 0.0 | NaN | 0.0 | 105.0 | 93.0 | 75.0 | 577.0 | NaN | NaN | NaN | NaN | NaN | 2021 | 1 |
| 1366 | 2021-01-01 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 2823 | ATL | Atlanta, GA | BWI | Baltimore, MD | 17:25 | 17:29 | 4.0 | 13.0 | 17:42 | 19:04 | 24.0 | 19:05 | 19:28 | 23.0 | 0.0 | NaN | 0.0 | 100.0 | 119.0 | 82.0 | 577.0 | 0.0 | 0.0 | 23.0 | 0.0 | 0.0 | 2021 | 1 |
| 1367 | 2021-01-01 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 2707 | ATL | Atlanta, GA | LGA | New York, NY | 19:50 | 20:22 | 32.0 | 14.0 | 20:36 | 22:07 | 7.0 | 22:05 | 22:14 | 9.0 | 0.0 | NaN | 0.0 | 135.0 | 112.0 | 91.0 | 762.0 | NaN | NaN | NaN | NaN | NaN | 2021 | 1 |
| 1368 | 2021-01-01 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 2568 | ATL | Atlanta, GA | LAS | Las Vegas, NV | 16:30 | 16:47 | 17.0 | 12.0 | 16:59 | 17:54 | 5.0 | 18:05 | 17:59 | -6.0 | 0.0 | NaN | 0.0 | 275.0 | 252.0 | 235.0 | 1747.0 | NaN | NaN | NaN | NaN | NaN | 2021 | 1 |
| 1369 | 2021-01-01 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 3796 | ATL | Atlanta, GA | JAX | Jacksonville, FL | 12:45 | 12:56 | 11.0 | 15.0 | 13:11 | 13:59 | 4.0 | 13:55 | 14:03 | 8.0 | 0.0 | NaN | 0.0 | 70.0 | 67.0 | 48.0 | 270.0 | NaN | NaN | NaN | NaN | NaN | 2021 | 1 |
| 1370 | 2021-01-01 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 3179 | ATL | Atlanta, GA | IND | Indianapolis, IN | 12:40 | 12:39 | -1.0 | 27.0 | 13:06 | 14:16 | 2.0 | 14:10 | 14:18 | 8.0 | 0.0 | NaN | 0.0 | 90.0 | 99.0 | 70.0 | 432.0 | NaN | NaN | NaN | NaN | NaN | 2021 | 1 |
| 1371 | 2021-01-01 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 2434 | ATL | Atlanta, GA | IND | Indianapolis, IN | 17:40 | 18:04 | 24.0 | 16.0 | 18:20 | 19:23 | 6.0 | 19:10 | 19:29 | 19.0 | 0.0 | NaN | 0.0 | 90.0 | 85.0 | 63.0 | 432.0 | 7.0 | 0.0 | 0.0 | 0.0 | 12.0 | 2021 | 1 |
| 1372 | 2021-01-01 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 2970 | ATL | Atlanta, GA | IAD | Washington, DC | 12:40 | 13:07 | 27.0 | 14.0 | 13:21 | 14:43 | 2.0 | 14:20 | 14:45 | 25.0 | 0.0 | NaN | 0.0 | 100.0 | 98.0 | 82.0 | 534.0 | 25.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2021 | 1 |
| FL_DATE | AIRLINE | AIRLINE_DOT | AIRLINE_CODE | DOT_CODE | FL_NUMBER | ORIGIN | ORIGIN_CITY | DEST | DEST_CITY | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | WHEELS_OFF | WHEELS_ON | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | CRS_ELAPSED_TIME | ELAPSED_TIME | AIR_TIME | DISTANCE | DELAY_DUE_CARRIER | DELAY_DUE_WEATHER | DELAY_DUE_NAS | DELAY_DUE_SECURITY | DELAY_DUE_LATE_AIRCRAFT | YEAR | MONTH | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17269926 | 2023-08-31 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 1378 | DCA | Washington, DC | MDW | Chicago, IL | 18:30 | 18:31 | 1.0 | 9.0 | 18:40 | 19:09 | 8.0 | 19:30 | 19:17 | -13.0 | 0.0 | NaN | 0.0 | 120.0 | 106.0 | 89.0 | 601.0 | NaN | NaN | NaN | NaN | NaN | 2023 | 8 |
| 17269929 | 2023-08-31 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 747 | DCA | Washington, DC | MDW | Chicago, IL | 09:15 | 09:12 | -3.0 | 29.0 | 09:41 | 10:09 | 3.0 | 10:10 | 10:12 | 2.0 | 0.0 | NaN | 0.0 | 115.0 | 120.0 | 88.0 | 601.0 | NaN | NaN | NaN | NaN | NaN | 2023 | 8 |
| 17269931 | 2023-08-31 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 713 | DCA | Washington, DC | MDW | Chicago, IL | 11:50 | 11:47 | -3.0 | 7.0 | 11:54 | 12:23 | 3.0 | 12:45 | 12:26 | -19.0 | 0.0 | NaN | 0.0 | 115.0 | 99.0 | 89.0 | 601.0 | NaN | NaN | NaN | NaN | NaN | 2023 | 8 |
| 17269934 | 2023-08-31 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 3710 | DCA | Washington, DC | MCO | Orlando, FL | 06:05 | 06:06 | 1.0 | 8.0 | 06:14 | 08:01 | 4.0 | 08:20 | 08:05 | -15.0 | 0.0 | NaN | 0.0 | 135.0 | 119.0 | 107.0 | 759.0 | NaN | NaN | NaN | NaN | NaN | 2023 | 8 |
| 17269935 | 2023-08-31 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 3664 | DCA | Washington, DC | MCI | Kansas City, MO | 12:50 | 12:44 | -6.0 | 12.0 | 12:56 | 14:03 | 4.0 | 14:25 | 14:07 | -18.0 | 0.0 | NaN | 0.0 | 155.0 | 143.0 | 127.0 | 949.0 | NaN | NaN | NaN | NaN | NaN | 2023 | 8 |
| 17269937 | 2023-08-31 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 3106 | DCA | Washington, DC | MCI | Kansas City, MO | 16:25 | 16:24 | -1.0 | 7.0 | 16:31 | 17:38 | 3.0 | 18:00 | 17:41 | -19.0 | 0.0 | NaN | 0.0 | 155.0 | 137.0 | 127.0 | 949.0 | NaN | NaN | NaN | NaN | NaN | 2023 | 8 |
| 17269939 | 2023-08-31 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 3068 | DAL | Dallas, TX | SAT | San Antonio, TX | 21:50 | 22:05 | 15.0 | 7.0 | 22:12 | 22:52 | 3.0 | 22:50 | 22:55 | 5.0 | 0.0 | NaN | 0.0 | 60.0 | 50.0 | 40.0 | 247.0 | NaN | NaN | NaN | NaN | NaN | 2023 | 8 |
| 17269940 | 2023-08-31 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 4795 | DAL | Dallas, TX | LAX | Los Angeles, CA | 14:50 | 15:14 | 24.0 | 15.0 | 15:29 | 16:15 | 10.0 | 16:00 | 16:25 | 25.0 | 0.0 | NaN | 0.0 | 190.0 | 191.0 | 166.0 | 1246.0 | 4.0 | 0.0 | 1.0 | 0.0 | 20.0 | 2023 | 8 |
| 17269941 | 2023-08-31 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 5171 | DAL | Dallas, TX | MCO | Orlando, FL | 20:45 | 20:47 | 2.0 | 8.0 | 20:55 | 00:07 | 6.0 | 00:20 | 00:13 | -7.0 | 0.0 | NaN | 0.0 | 155.0 | 146.0 | 132.0 | 973.0 | NaN | NaN | NaN | NaN | NaN | 2023 | 8 |
| 17269942 | 2023-08-31 | Southwest Airlines Co. | Southwest Airlines Co.: WN | WN | 19393 | 1902 | DCA | Washington, DC | MCO | Orlando, FL | 14:00 | 14:00 | 0.0 | 12.0 | 14:12 | 16:50 | 7.0 | 16:20 | 16:57 | 37.0 | 0.0 | NaN | 0.0 | 140.0 | 177.0 | 158.0 | 759.0 | 0.0 | 0.0 | 37.0 | 0.0 | 0.0 | 2023 | 8 |